-
Re: How can I get the month text
For three digit month names you can avoid nasty nested IFs by using a much simpler formula: =MID("JanFebMarAprMayJunJulAugSepOctNovDec", (Mth@row * 3) - 2, 3)4 · -
Re: How to extract just the month name from a date
Nested IFs are useful when you need the full month name, but for three digit month names you can use a much simpler formula: =MID("JanFebMarAprMayJunJulAugSepOctNovDec", (Mth@row * 3) - 2, …6 · -
Re: Formula - Return month as text from a date cell.
If you only need three digit month names the formula is much simpler: =MID("JanFebMarAprMayJunJulAugSepOctNovDec", (Mth@row * 3) - 2, 3)6 · -
Re: Help with Syntax
That's the way grouping works, so you are stuck with it appearing For your column formula you will need to add @row to your column specifiers: =IF([Type]@row = "Highlights", "1 - Highl…1 · -
Re: Dashboard Question
Hi darrink That's how it is done in Smartsheet, although the "I'd like to publish" indicates that you might be manually pulling the data into the new sheet. Look for a way to automate or si…1 ·